Release 10.1A: OpenEdge Reporting:
Deploying Crystal Reports

Using Crystal Reports to connect to a data source

To create a report with Crystal Reports you must first connect to a database. Remember, the database must be running in order for you to connect. For information on creating a sample database and connecting to it, see Chapter 1, " Introduction."

To connect to a running database:

Start Crystal Reports by clicking Start Programs Crystal Reports.
The Welcome to Crystal Reports dialog box appears:



Select As a Blank Report option in the Create a New Crystal Report Document area and click OK.The Database Expert dialog box appears:



Click + next to the Create New Connection folder to view subfolders. Double click the ODBC (RDO) folder. The ODBC (RDO) dialog box appears:



Select Accounting from the Data Source Name list and click Next. The ODBC (RDO) dialog box prompts you for logon information:



Enter your user identification and password and click Finish. The Logon to OpenEdge SQL Driver dialog box appears:



Enter your user identification and password and click OK. The Database Expert dialog box appears, showing a list of tables of the database to which you have connected:

Now that you have connected to the database, you can select the specific information you will need for your report.